/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1-本地库
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : localhost:3306
 Source Schema         : yf_base

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 14/03/2022 14:51:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for el_cfg_base
-- ----------------------------
DROP TABLE IF EXISTS `el_cfg_base`;
CREATE TABLE `el_cfg_base` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `site_name` varchar(255) DEFAULT NULL COMMENT '系统名称',
  `front_logo` varchar(255) DEFAULT NULL COMMENT '前端LOGO',
  `back_logo` varchar(255) DEFAULT NULL COMMENT '后台LOGO',
  `copy_right` varchar(255) DEFAULT NULL COMMENT '版权信息',
  `tmp_dir` varchar(255) DEFAULT NULL COMMENT '系统临时目录',
  `upload_type` int NOT NULL DEFAULT '1' COMMENT '存储方案1本地2阿里云OSS',
  `live_type` int NOT NULL DEFAULT '0' COMMENT '1阿里云',
  `h5_code` varchar(500) DEFAULT NULL COMMENT '手机端二维码',
  `mp_code` varchar(500) DEFAULT NULL COMMENT '小程序二维码',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统设置';

-- ----------------------------
-- Records of el_cfg_base
-- ----------------------------
BEGIN;
INSERT INTO `el_cfg_base` (`id`, `site_name`, `front_logo`, `back_logo`, `copy_right`, `tmp_dir`, `upload_type`, `live_type`, `h5_code`, `mp_code`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1', '云帆快速开发框架', 'https://yfhl-files.oss-cn-beijing.aliyuncs.com/2021/10/15/1634281379257-8e455170.png', 'https://yfhl-files.oss-cn-beijing.aliyuncs.com/2021/10/15/1634281439698-5efc61ad.png', '&copy; 2021北京云帆互联科技有限公司', '/Users/bool/work/temp/', 1, 1, 'https://yfhl-files.oss-cn-beijing.aliyuncs.com/2021/9/30/1632971330994-0be708b9.png', 'https://yfhl-files.oss-cn-beijing.aliyuncs.com/2021/9/30/1632971288854-0615b246.jpg', '2020-12-03 16:51:30', '2022-02-10 14:38:35', '', '10001', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_depart
-- ----------------------------
DROP TABLE IF EXISTS `sys_depart`;
CREATE TABLE `sys_depart` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `dept_type` int NOT NULL DEFAULT '1' COMMENT '1公司2部门',
  `parent_id` varchar(32) NOT NULL COMMENT '所属上级',
  `dept_name` varchar(255) NOT NULL DEFAULT '' COMMENT '部门名称',
  `dept_code` varchar(255) NOT NULL DEFAULT '' COMMENT '部门编码',
  `dept_level` int NOT NULL DEFAULT '0' COMMENT '部门层级',
  `sort` int NOT NULL DEFAULT '0' COMMENT '排序',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `dept_code` (`dept_code`) USING BTREE,
  KEY `parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='部门信息';

-- ----------------------------
-- Records of sys_depart
-- ----------------------------
BEGIN;
INSERT INTO `sys_depart` (`id`, `dept_type`, `parent_id`, `dept_name`, `dept_code`, `dept_level`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1441328268501381121', 1, '0', '云帆互联', 'A01', 0, 2, '2021-09-24 17:06:52', '2021-09-24 17:06:52', '', '', 0);
INSERT INTO `sys_depart` (`id`, `dept_type`, `parent_id`, `dept_name`, `dept_code`, `dept_level`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1447829893265002498', 1, '1441328268501381121', '技术部', 'A01A01', 0, 1, '2021-10-12 15:42:01', '2021-10-12 15:42:00', '10001', '', 0);
INSERT INTO `sys_depart` (`id`, `dept_type`, `parent_id`, `dept_name`, `dept_code`, `dept_level`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1447829920330846210', 1, '1441328268501381121', '财务部', 'A01A02', 0, 2, '2021-10-12 15:42:07', '2021-10-12 15:42:07', '10001', '', 0);
INSERT INTO `sys_depart` (`id`, `dept_type`, `parent_id`, `dept_name`, `dept_code`, `dept_level`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1447829960050905090', 1, '1441328268501381121', '商务部', 'A01A03', 0, 3, '2021-10-12 15:42:17', '2021-10-12 15:42:16', '10001', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dic
-- ----------------------------
DROP TABLE IF EXISTS `sys_dic`;
CREATE TABLE `sys_dic` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `code` varchar(255) DEFAULT NULL COMMENT '字典编码',
  `type` int DEFAULT NULL COMMENT '1分类字典,2数据字典',
  `title` varchar(255) DEFAULT NULL COMMENT '字典名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '字典描述',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='分类字典';

-- ----------------------------
-- Records of sys_dic
-- ----------------------------
BEGIN;
INSERT INTO `sys_dic` (`id`, `code`, `type`, `title`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399934295992238081', 'role_type', 1, '角色类型', '角色的主要类型', '2021-06-02 11:42:00', '2021-06-02 11:42:00', '', '', 1);
INSERT INTO `sys_dic` (`id`, `code`, `type`, `title`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399935914490269698', 'data_scope', 1, '数据权限', '角色数据权限范围', '2021-06-02 11:48:26', '2021-06-02 11:48:26', '', '', 1);
INSERT INTO `sys_dic` (`id`, `code`, `type`, `title`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1418834107713986562', 'dept_type', 1, '机构类型', '机构类型', '2021-07-24 15:23:06', '2021-07-24 15:23:06', '', '', 1);
INSERT INTO `sys_dic` (`id`, `code`, `type`, `title`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1463077882027855873', 'log_type', 1, '日志类型', '日志分模块类型记录', '2021-11-23 17:32:04', '2021-11-23 17:32:04', '', '', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_dic_value
-- ----------------------------
DROP TABLE IF EXISTS `sys_dic_value`;
CREATE TABLE `sys_dic_value` (
  `id` varchar(32) NOT NULL COMMENT 'ID/字典编码',
  `dic_code` varchar(255) DEFAULT NULL COMMENT '归属字典',
  `value` varchar(255) DEFAULT NULL COMMENT '子项编码',
  `title` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `parent_id` varchar(32) DEFAULT NULL COMMENT '上级ID',
  `remark` varchar(255) DEFAULT NULL COMMENT '描述',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='分类字典值';

-- ----------------------------
-- Records of sys_dic_value
-- ----------------------------
BEGIN;
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1356065526639505409', 'exam_open_type', '1', '完全公开', '0', NULL, '2021-02-01 10:23:10', '2021-02-01 10:23:10', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399934414120615937', 'role_type', '1', '学员/前端用户', '0', '进入前端的用户', '2021-06-02 11:42:28', '2021-06-02 11:42:28', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399934480537419777', 'role_type', '2', '管理员/教师/后端用户', '0', '进入后端的用户', '2021-06-02 11:42:44', '2021-06-02 11:42:44', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399936107176595458', 'data_scope', '1', '仅本人数据', '0', '仅本人数据', '2021-06-02 11:49:12', '2021-06-02 11:49:12', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399936146162651137', 'data_scope', '2', '本部门数据', '0', '本部门数据', '2021-06-02 11:49:21', '2021-06-02 11:49:21', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399936188902608897', 'data_scope', '3', '本部门及以下', '0', '本部门及以下', '2021-06-02 11:49:31', '2021-06-02 11:49:31', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399936230719819777', 'data_scope', '4', '全部数据', '0', '全部数据', '2021-06-02 11:49:41', '2021-06-02 11:49:41', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1418834160377667586', 'dept_type', '1', '公司', '0', NULL, '2021-07-24 15:23:19', '2021-07-24 15:23:19', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1418834199745404930', 'dept_type', '2', '部门', '0', NULL, '2021-07-24 15:23:28', '2021-07-24 15:23:28', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1418834237095682049', 'dept_type', '3', '小组', '0', NULL, '2021-07-24 15:23:37', '2021-07-24 15:23:37', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1463078147888009218', 'log_type', 'login', '用户登录', '0', NULL, '2021-11-23 17:33:07', '2021-11-23 17:33:07', '', '', 1);
INSERT INTO `sys_dic_value` (`id`, `dic_code`, `value`, `title`, `parent_id`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1463110598801145857', 'log_type', 'system', '系统模块', '0', NULL, '2021-11-23 19:42:04', '2021-11-23 19:42:04', '', '', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `log_type` varchar(255) DEFAULT NULL COMMENT '日志类别',
  `uri` varchar(500) DEFAULT NULL COMMENT '请求地址',
  `title` varchar(255) NOT NULL COMMENT '日志名称',
  `user_id` varchar(32) NOT NULL DEFAULT '' COMMENT '用户ID',
  `ip` varchar(255) NOT NULL DEFAULT '' COMMENT 'IP地址',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `data` longtext NOT NULL COMMENT '日志明细',
  `success` tinyint DEFAULT NULL COMMENT '是否成功',
  `log` longtext COMMENT '错误日志',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `parent_id` varchar(32) DEFAULT NULL COMMENT '上级菜单',
  `menu_type` int NOT NULL DEFAULT '1' COMMENT '1菜单2功能',
  `permission_tag` varchar(255) DEFAULT NULL COMMENT '权限标识',
  `path` varchar(255) DEFAULT NULL COMMENT '访问路径',
  `component` varchar(255) DEFAULT NULL COMMENT '视图或Layout',
  `redirect` varchar(255) DEFAULT NULL COMMENT '跳转地址',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `meta_title` varchar(255) DEFAULT NULL COMMENT '路由标题',
  `meta_icon` varchar(255) DEFAULT NULL COMMENT '路由标题',
  `meta_active_menu` varchar(255) DEFAULT NULL COMMENT '高亮菜单',
  `meta_no_cache` tinyint DEFAULT NULL COMMENT '是否缓存',
  `hidden` tinyint DEFAULT NULL COMMENT '是否隐藏',
  `sort` int DEFAULT NULL COMMENT '越小越前',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `parent_id` (`parent_id`) USING BTREE,
  KEY `menu_type` (`menu_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529427607568', '0', 1, NULL, '/admin', 'Layout', '/admin/dashboard', 'Admin', '管理首页', 'component', NULL, 1, 0, 3, '2021-03-07 11:08:18', '2021-06-02 18:18:14', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529427607569', '1367010529427607568', 1, NULL, '/admin/dashboard', 'dashboard', NULL, 'Dashboard', '管理首页', '', NULL, 1, 0, 1, '2021-03-07 11:08:18', '2021-06-02 18:18:23', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996174', '0', 1, NULL, '/admin/sys', 'Layout', '/admin/sys/config', 'Sys', '系统设置', 'configure', NULL, 1, 0, 11, '2021-03-07 11:08:18', '2021-12-15 09:57:18', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996175', '1367010529435996174', 1, 'sys:config', '/admin/sys/config', 'sys/config', NULL, 'SysConfig', '系统配置', '', NULL, 1, 0, 1, '2021-03-07 11:08:18', '2021-05-31 10:14:20', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996176', '1367010529435996174', 1, 'sys:menu', '/admin/sys/menu', 'sys/menu', NULL, 'SysMenu', '菜单管理', '', NULL, 1, 0, 2, '2021-03-07 11:08:18', '2021-05-31 10:14:26', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996177', '1493422620346011649', 1, 'sys:depart', '/admin/sys/depart', 'sys/depart', '', 'SysDepart', '部门管理', '', NULL, 1, 0, 4, '2021-03-07 11:08:18', '2022-02-15 11:41:33', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996178', '1493422620346011649', 1, 'sys:role', '/admin/sys/role', 'sys/role', NULL, 'SysRole', '角色管理', '', NULL, 1, 0, 3, '2021-03-07 11:08:18', '2022-02-15 11:41:06', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996179', '1493422620346011649', 1, 'sys:user', '/admin/sys/user', 'sys/user', NULL, 'SysUser', '用户管理', '', NULL, 1, 0, 5, '2021-03-07 11:08:18', '2022-02-15 11:41:43', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996180', '1367010529435996179', 2, 'sys:user:points', '/admin/sys/user/points/:id', 'user/points', NULL, 'UserPoints', '积分明细', NULL, '/admin/sys/user', 1, 1, 6, '2021-03-07 11:08:18', '2021-03-07 11:08:18', '', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996183', '1367010529435996174', 1, 'sys:dict:catalog', '/admin/sys/dict-catalog', 'sys/dict/catalog', NULL, 'DictCatalog', '分类字典', '', NULL, 1, 0, 9, '2021-03-07 11:08:18', '2021-10-13 10:50:55', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1367010529435996184', '1367010529435996174', 1, 'sys:dict:value', '/admin/sys/dict-data', 'sys/dict/dic', NULL, 'DictData', '数据字典', '', NULL, 1, 0, 10, '2021-03-07 11:08:18', '2021-10-13 10:50:55', '', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399263684152385537', '1367010529435996175', 2, 'sys:config:update', NULL, NULL, NULL, NULL, '修改配置', NULL, NULL, 1, NULL, 1, '2021-05-31 15:17:14', '2021-05-31 15:17:14', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399266644605394945', '1367010529435996176', 2, 'sys:menu:add', NULL, NULL, NULL, NULL, '添加菜单', NULL, NULL, 1, NULL, 1, '2021-05-31 15:29:00', '2021-05-31 15:28:59', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399266713060630529', '1367010529435996176', 2, 'sys:menu:update', NULL, NULL, NULL, NULL, '修改菜单', NULL, NULL, 1, NULL, 2, '2021-05-31 15:29:16', '2021-05-31 15:29:16', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399266787438223361', '1367010529435996176', 2, 'sys:menu:delete', NULL, NULL, NULL, NULL, '删除菜单', NULL, NULL, 1, NULL, 3, '2021-05-31 15:29:34', '2021-05-31 15:29:33', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399266868300210177', '1367010529435996176', 2, 'sys:menu:sort', NULL, NULL, NULL, NULL, '菜单排序', NULL, NULL, 1, NULL, 4, '2021-05-31 15:29:53', '2021-05-31 15:29:53', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399266973875036161', '1367010529435996178', 2, 'sys:role:add', NULL, NULL, NULL, NULL, '添加角色', NULL, NULL, 1, NULL, 1, '2021-05-31 15:30:18', '2021-05-31 15:30:18', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399267041344610306', '1367010529435996178', 2, 'sys:role:update', NULL, NULL, NULL, NULL, '修改角色', NULL, NULL, 1, NULL, 2, '2021-05-31 15:30:34', '2021-05-31 15:30:34', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399267166364229634', '1367010529435996178', 2, 'sys:role:delete', NULL, NULL, NULL, NULL, '删除角色', NULL, NULL, 1, NULL, 3, '2021-05-31 15:31:04', '2021-05-31 15:31:04', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399270377145884673', '1367010529435996178', 2, 'sys:role:grant', NULL, NULL, NULL, NULL, '角色授权', NULL, NULL, 1, NULL, 4, '2021-05-31 15:43:50', '2021-05-31 15:43:49', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399270608335921153', '1367010529435996177', 2, 'sys:depart:add', NULL, NULL, NULL, NULL, '添加部门', NULL, NULL, 1, NULL, 1, '2021-05-31 15:44:45', '2021-05-31 15:44:44', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399270698039500801', '1367010529435996177', 2, 'sys:depart:update', NULL, NULL, NULL, NULL, '修改部门', NULL, NULL, 1, NULL, 2, '2021-05-31 15:45:06', '2021-05-31 15:45:06', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399270777932603393', '1367010529435996177', 2, 'sys:depart:delete', NULL, NULL, NULL, NULL, '删除部门', NULL, NULL, 1, NULL, 3, '2021-05-31 15:45:25', '2021-05-31 15:45:25', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399271425583472641', '1367010529435996179', 2, 'sys:user:add', NULL, NULL, NULL, NULL, '添加用户', NULL, NULL, 1, NULL, 1, '2021-05-31 15:48:00', '2021-05-31 15:47:59', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399271482458234882', '1367010529435996179', 2, 'sys:user:update', NULL, NULL, NULL, NULL, '修改用户', NULL, NULL, 1, NULL, 2, '2021-05-31 15:48:13', '2021-05-31 15:48:13', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399271543669907458', '1367010529435996179', 2, 'sys:user:delete', NULL, NULL, NULL, NULL, '删除用户', NULL, NULL, 1, NULL, 3, '2021-05-31 15:48:28', '2021-05-31 15:48:27', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399271602981560321', '1367010529435996179', 2, 'sys:user:import', NULL, NULL, NULL, NULL, '导入用户', NULL, NULL, 1, NULL, 4, '2021-05-31 15:48:42', '2021-05-31 15:48:42', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399271669553553410', '1367010529435996179', 2, 'sys:user:export', NULL, NULL, NULL, NULL, '导出用户', NULL, NULL, 1, NULL, 5, '2021-05-31 15:48:58', '2021-05-31 15:48:57', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399272795329912833', '1367010529435996183', 2, 'sys:dict:catalog:add', NULL, NULL, NULL, NULL, '添加分类', NULL, NULL, 1, NULL, 1, '2021-05-31 15:53:26', '2021-05-31 15:54:09', '10001', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399272872786124802', '1367010529435996183', 2, 'sys:dict:catalog:update', NULL, NULL, NULL, NULL, '修改分类', NULL, NULL, 1, NULL, 2, '2021-05-31 15:53:45', '2021-05-31 15:53:44', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399272937902694402', '1367010529435996183', 2, 'sys:dict:catalog:delete', NULL, NULL, NULL, NULL, '删除分类', NULL, NULL, 1, NULL, 3, '2021-05-31 15:54:00', '2021-05-31 15:54:00', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399273058870616065', '1367010529435996183', 2, 'sys:dict:catalog:sub', NULL, NULL, NULL, NULL, '维护子项', NULL, NULL, 1, NULL, 4, '2021-05-31 15:54:29', '2021-05-31 15:54:29', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399273168916570113', '1367010529435996184', 2, 'sys:dict:value:add', NULL, NULL, NULL, NULL, '添加字典', NULL, NULL, 1, NULL, 1, '2021-05-31 15:54:55', '2021-05-31 15:54:55', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399273214881947650', '1367010529435996184', 2, 'sys:dict:value:update', NULL, NULL, NULL, NULL, '修改字典', NULL, NULL, 1, NULL, 2, '2021-05-31 15:55:06', '2021-05-31 15:55:18', '10001', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399273324386836482', '1367010529435996184', 2, 'sys:dict:value:delete', NULL, NULL, NULL, NULL, '删除字典', NULL, NULL, 1, NULL, 3, '2021-05-31 15:55:32', '2021-05-31 15:55:32', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399273388576464897', '1367010529435996184', 2, 'sys:dict:value:sub', NULL, NULL, NULL, NULL, '维护子项', NULL, NULL, 1, NULL, 4, '2021-05-31 15:55:48', '2021-05-31 15:55:47', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1399273800431951873', '1367010529435996179', 2, 'sys:user:state', NULL, NULL, NULL, NULL, '启用/禁用', NULL, NULL, 1, NULL, 7, '2021-05-31 15:57:26', '2021-05-31 15:57:25', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1427986541655293954', '1367010529435996177', 1, 'sys:depart:add:root', NULL, NULL, NULL, 'SysDepartAddRoot', '添加主部门', NULL, NULL, 1, 1, 4, '2021-08-18 21:31:37', '2021-08-18 21:31:43', '10001', '10001', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1463072343711944706', '1367010529435996174', 1, 'sys:log', '/admin/sys/log', 'sys/log', NULL, 'SysLog', '操作日志', NULL, NULL, 1, NULL, 11, '2021-11-23 17:10:04', '2021-11-23 17:10:03', '10001', '', 1);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1473490644724244482', '1367010529435996179', 2, 'sys:user:batch-dept', NULL, NULL, NULL, 'BatchDept', '批量迁移部门', NULL, '/admin/sys/user', NULL, 1, 8, '2021-12-22 11:08:40', '2021-12-22 11:09:43', '10001', '10001', 0);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1473490873397698561', '1367010529435996179', 2, 'sys:user:batch-role', NULL, NULL, NULL, 'BatchRole', '批量修改角色', NULL, '/admin/sys/user', NULL, 1, 9, '2021-12-22 11:09:35', '2021-12-22 11:09:35', '10001', '', 0);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_type`, `permission_tag`, `path`, `component`, `redirect`, `name`, `meta_title`, `meta_icon`, `meta_active_menu`, `meta_no_cache`, `hidden`, `sort`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422620346011649', '0', 1, NULL, '/admin/user/', 'Layout', NULL, 'SysUser', '用户管理', 'peoples', NULL, NULL, NULL, 12, '2022-02-15 11:11:14', '2022-02-15 11:11:13', '10001', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `title` varchar(255) DEFAULT NULL COMMENT '公告标题',
  `content` longtext COMMENT '公告内容',
  `state` int DEFAULT '0' COMMENT '状态',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统公告';

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` varchar(32) NOT NULL COMMENT '角色ID',
  `role_name` varchar(255) NOT NULL DEFAULT '' COMMENT '角色名称',
  `role_type` int NOT NULL COMMENT '1学员2管理员',
  `data_scope` int NOT NULL COMMENT '数据权限',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注信息',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `role_name`, `role_type`, `data_scope`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('admin', '超级管理员', 2, 4, NULL, '2020-12-03 16:52:16', '2021-05-31 18:59:24', '', '10001', 1);
INSERT INTO `sys_role` (`id`, `role_name`, `role_type`, `data_scope`, `remark`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('user', '普通用户', 1, 4, NULL, '2020-12-03 16:52:16', '2021-06-01 21:31:14', '', '10001', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `role_id` varchar(32) NOT NULL COMMENT '角色ID',
  `menu_id` varchar(32) NOT NULL COMMENT '菜单ID',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色菜单授权';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795013607425', 'admin', '1367010529427607568', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795021996034', 'admin', '1367010529427607569', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795021996035', 'admin', '1367010529435996174', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795026190337', 'admin', '1367010529435996175', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795026190338', 'admin', '1399263684152385537', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795030384642', 'admin', '1367010529435996176', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795030384643', 'admin', '1399266644605394945', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795034578945', 'admin', '1399266713060630529', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795034578946', 'admin', '1399266787438223361', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795034578947', 'admin', '1399266868300210177', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795038773249', 'admin', '1367010529435996178', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795038773250', 'admin', '1399266973875036161', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795042967554', 'admin', '1399267041344610306', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795042967555', 'admin', '1399267166364229634', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795042967556', 'admin', '1399270377145884673', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795047161858', 'admin', '1367010529435996177', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795047161859', 'admin', '1399270608335921153', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795051356162', 'admin', '1399270698039500801', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795051356163', 'admin', '1399270777932603393', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795051356164', 'admin', '1427986541655293954', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795055550466', 'admin', '1367010529435996179', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795055550467', 'admin', '1399271425583472641', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795055550468', 'admin', '1399271482458234882', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795055550469', 'admin', '1399271543669907458', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795059744770', 'admin', '1399271602981560321', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795059744771', 'admin', '1399271669553553410', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795059744772', 'admin', '1367010529435996180', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795059744773', 'admin', '1399273800431951873', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795059744774', 'admin', '1367010529435996182', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795063939073', 'admin', '1399272452055490562', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795063939074', 'admin', '1399272540358172673', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795063939075', 'admin', '1399272617801801730', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795068133377', 'admin', '1367010529435996183', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795068133378', 'admin', '1399272795329912833', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795068133379', 'admin', '1399272872786124802', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795068133380', 'admin', '1399272937902694402', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795072327681', 'admin', '1399273058870616065', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795072327682', 'admin', '1367010529435996184', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795072327683', 'admin', '1399273168916570113', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795072327684', 'admin', '1399273214881947650', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795076521986', 'admin', '1399273324386836482', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795076521987', 'admin', '1399273388576464897', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795076521988', 'admin', '1463072343711944706', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1493422795080716289', 'admin', '1493422620346011649', '2022-02-15 11:11:55', '2022-02-15 11:11:55', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1503192159843270657', 'user', '1367010529427607568', '2022-03-14 10:11:53', '2022-03-14 10:11:53', '', '', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1503192159851659266', 'user', '1367010529427607569', '2022-03-14 10:11:53', '2022-03-14 10:11:53', '', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `user_name` varchar(255) NOT NULL DEFAULT '' COMMENT '用户名',
  `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  `face` varchar(500) DEFAULT NULL COMMENT '人脸照片',
  `real_name` varchar(255) NOT NULL DEFAULT '' COMMENT '真实姓名',
  `password` varchar(255) NOT NULL DEFAULT '' COMMENT '密码',
  `salt` varchar(255) NOT NULL DEFAULT '' COMMENT '密码盐',
  `state` int NOT NULL DEFAULT '0' COMMENT '状态',
  `points` int NOT NULL DEFAULT '0' COMMENT '积分',
  `id_card` varchar(255) DEFAULT '' COMMENT '身份证号码',
  `mobile` varchar(255) DEFAULT NULL COMMENT '手机号',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `dept_code` varchar(32) DEFAULT NULL COMMENT '部门编码',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '修改人',
  `data_flag` int NOT NULL DEFAULT '0' COMMENT '数据标识',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `dept_code` (`dept_code`) USING BTREE,
  KEY `user_name` (`user_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `user_name`, `avatar`, `face`, `real_name`, `password`, `salt`, `state`, `points`, `id_card`, `mobile`, `email`, `dept_code`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('10001', 'admin', 'https://yfhl-files.oss-cn-beijing.aliyuncs.com/2021/12/4/1638589680637-a0faf904.jpg', 'https://yfhl-files.oss-cn-beijing.aliyuncs.com/2021/11/5/1636104721186-99c9c38a.jpg', '超管A', '06681cd08837b21adf6b5ef9279d403d', 'XoFFuS', 0, 100, '', NULL, NULL, 'A01A01', '2020-12-03 16:52:10', '2021-06-07 17:10:29', '', '10001', 1);
INSERT INTO `sys_user` (`id`, `user_name`, `avatar`, `face`, `real_name`, `password`, `salt`, `state`, `points`, `id_card`, `mobile`, `email`, `dept_code`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('10002', 'user', 'https://yfhl-files.oss-cn-beijing.aliyuncs.com/2021/9/30/1632984678858-0cc860b7.jpg', NULL, '学员A', '27810f52e7c2227b060257507905636a', 'EgvLUH', 0, 200, '500000198501010203', '18603038204', '835487894@qq.com', 'A01A02', '2020-12-03 16:52:10', '2021-10-12 16:39:41', '', '10001', 1);
INSERT INTO `sys_user` (`id`, `user_name`, `avatar`, `face`, `real_name`, `password`, `salt`, `state`, `points`, `id_card`, `mobile`, `email`, `dept_code`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1503188111239229441', 'zhangsan', '', NULL, '张三', '21412a5ba65c55c90a99da7a5934a3c6', 'yOxkrf', 0, 0, '', NULL, NULL, NULL, '2022-03-14 09:55:48', '2022-03-14 09:55:48', '', '', 0);
INSERT INTO `sys_user` (`id`, `user_name`, `avatar`, `face`, `real_name`, `password`, `salt`, `state`, `points`, `id_card`, `mobile`, `email`, `dept_code`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1503196931254140930', 'dora', '', NULL, '小多多', 'c56f0853f72594466ad30a96c4ae4695', 'CVbCVg', 0, 0, '', NULL, NULL, NULL, '2022-03-14 10:30:51', '2022-03-14 10:30:51', '', '', 0);
INSERT INTO `sys_user` (`id`, `user_name`, `avatar`, `face`, `real_name`, `password`, `salt`, `state`, `points`, `id_card`, `mobile`, `email`, `dept_code`, `create_time`, `update_time`, `create_by`, `update_by`, `data_flag`) VALUES ('1503261149230071809', 'mumu', '', NULL, '木木', '5bfb2e11c200758b9e07e51dca61fecc', 'JcTCVC', 0, 0, '', NULL, NULL, NULL, '2022-03-14 14:46:02', '2022-03-14 14:46:01', '', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `user_id` varchar(32) NOT NULL COMMENT '用户ID',
  `role_id` varchar(32) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户角色';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('1459067249791967234', '10001', 'admin');
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('1462976694723452930', '10002', 'user');
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('1503188111352475650', '1503188111239229441', 'user');
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('1503196931296083970', '1503196931254140930', 'user');
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('1503261149339123714', '1503261149230071809', 'user');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
